use master
go
USE Bank
GO
DELETE FROM [User]

GO
/***************************************************************************/
			/*	 Insert Into Table [dbo].[User]    */
/***************************************************************************/
INSERT INTO [User] ([userID], [password], [fullName], [address], [email], [telephone], [gender])
VALUES (N'admin', N'admin', N'Nguyen Ha', N'Ha Noi', N'hanguyen234@gmail.com', N'0947731431','male')

INSERT INTO [User] ([userID], [password], [fullName], [address], [email], [telephone], [gender])
VALUES (N'A001', N'123', N'Van Ha', N'HN', N'hanguyen234@gmail.com', N'0947731431','male')

INSERT INTO [User] ([userID], [password], [fullName], [address], [email], [telephone], [gender])
VALUES (N'A002', N'123', N'Van Duy', N'HN', N'duybv.at@gmail.com', N'0979223343','male')

INSERT INTO [User] ([userID], [password], [fullName], [address], [email], [telephone], [gender])
VALUES (N'A003', N'123', N'Hai Lan', N'HN', N'lanth@gmail.com', N'0972327233','female')

INSERT INTO [User] ([userID], [password], [fullName], [address], [email], [telephone], [gender])
VALUES (N'A004', N'123', N'Quoc Hung', N'HN', N'hungnq.bm@gmail.com', N'0975789939','male')

INSERT INTO [User] ([userID], [password], [fullName], [address], [email], [telephone], [gender])
VALUES (N'A005', N'123', N'Van Can', N'HN', N'dvcan@gmail.com', N'0975789939','female')

INSERT INTO [User] ([userID], [password], [fullName], [address], [email], [telephone], [gender])
VALUES (N'A009', N'123', N'Do Viet Anh', N'HN', N'anhdv@gmail.com', N'0975789939','male')

GO

DELETE FROM [AccountType]

GO
/***************************************************************************/
			/*	 Insert Into Table [dbo].[AccountType]    */
/***************************************************************************/
INSERT INTO [AccountType] ([typeID], [typeName])
VALUES (N'TYPE1', N'Checking')

INSERT INTO [AccountType] ([typeID], [typeName])
VALUES (N'TYPE2', N'Saving')

INSERT INTO [AccountType] ([typeID], [typeName])
VALUES (N'TYPE3', N'Credit Card')

GO
DELETE FROM [Account]

GO
/***************************************************************************/
			/*	 Insert Into Table [dbo].[Account]    */
/***************************************************************************/
INSERT INTO [Account] ([accountID], [userID], [typeID], [balance], [currencyCode], [withdrawable], [depositable])
VALUES (N'admin_01', N'admin', N'TYPE1', 5000, N'CUR01', 0,0)

INSERT INTO [Account] ([accountID], [userID], [typeID], [balance], [currencyCode], [withdrawable], [depositable])
VALUES (N'admin_02', N'admin', N'TYPE2', 5000, N'CUR01', 0,1)

INSERT INTO [Account] ([accountID], [userID], [typeID], [balance], [currencyCode], [withdrawable], [depositable])
VALUES (N'admin_03', N'admin', N'TYPE3', 5000, N'CUR01', 1,1)

INSERT INTO [Account] ([accountID], [userID], [typeID], [balance], [currencyCode], [withdrawable], [depositable])
VALUES (N'A001_01', N'A001', N'TYPE1', 5000, N'CUR01', 0,1)

INSERT INTO [Account] ([accountID], [userID], [typeID], [balance], [currencyCode], [withdrawable], [depositable])
VALUES (N'A001_02', N'A001', N'TYPE2', 5000, N'CUR01', 0,1)

INSERT INTO [Account] ([accountID], [userID], [typeID], [balance], [currencyCode], [withdrawable], [depositable])
VALUES (N'A001_03', N'A001', N'TYPE3', 5000, N'CUR01', 0,1)

INSERT INTO [Account] ([accountID], [userID], [typeID], [balance], [currencyCode], [withdrawable], [depositable])
VALUES (N'A0021', N'A001', N'TYPE1', 5000, N'CUR01', 0,1)

INSERT INTO [Account] ([accountID], [userID], [typeID], [balance], [currencyCode], [withdrawable], [depositable])
VALUES (N'A0022', N'A001', N'TYPE2', 5000, N'CUR01', 0,1)

INSERT INTO [Account] ([accountID], [userID], [typeID], [balance], [currencyCode], [withdrawable], [depositable])
VALUES (N'A0023', N'A001', N'TYPE3', 5000, N'CUR01', 0,1)

INSERT INTO [Account] ([accountID], [userID], [typeID], [balance], [currencyCode], [withdrawable], [depositable])
VALUES (N'A0031', N'A001', N'TYPE1', 5000, N'CUR01', 0,1)

INSERT INTO [Account] ([accountID], [userID], [typeID], [balance], [currencyCode], [withdrawable], [depositable])
VALUES (N'A0032', N'A001', N'TYPE2', 5000, N'CUR01', 0,1)

INSERT INTO [Account] ([accountID], [userID], [typeID], [balance], [currencyCode], [withdrawable], [depositable])
VALUES (N'A0033', N'A001', N'TYPE3', 5000, N'CUR01', 0,1)


INSERT INTO [Account] ([accountID], [userID], [typeID], [balance], [currencyCode], [withdrawable], [depositable])
VALUES (N'Acc05', N'A002', N'TYPE1', 5000, N'CUR01', 0,0)

INSERT INTO [Account] ([accountID], [userID], [typeID], [balance], [currencyCode], [withdrawable], [depositable])
VALUES (N'Acc06', N'A003', N'TYPE3', 5000, N'CUR01', 1,1)

GO
DELETE FROM [Currency]

GO
/***************************************************************************/
			/*	 Insert Into Table [dbo].[AccountType]    */
/***************************************************************************/
INSERT INTO [Currency] ([currencyCode], [currencySymbol])
VALUES (N'CUR01', N'$')

INSERT INTO [Currency] ([currencyCode], [currencySymbol])
VALUES (N'CUR02', N'VND')

GO


GO
/***************************************************************************/
			/*	 Insert Into Table [dbo].[Transaction]    */
/***************************************************************************/
INSERT INTO [Transaction] ([accountID],[date],[action])
VALUES ( N'Acc01',N'11/11/2001',N'check')
INSERT INTO [Transaction] ([accountID],[date],[action])
VALUES ( N'Acc01',N'11/11/2001',N'saving')

GO